set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions= 20;
set hive.exec.max.dynamic.partitions.pernode=20;


insert overwrite table jms_dim.dim_tab_exam_subject_list_dt partition(dt)
select
exam_id
,exam_type
,exam_title
,exam_image
,choose_a
,choose_b
,choose_c
,choose_d
,answer
,analysis
,userccde
,username
,create_time
,update_time
,create_network_id
,create_network_code
,create_network_name
,franch_network_id
,franch_network_code
,franch_network_name
,proxy_network_id
,proxy_network_code
,proxy_network_name
,exam_tag_id
,exam_tag_name
,use_object
,option_type
,effect_start_time
,effect_end_time
,status
,stop_answer_option
,dt
from
jms_ods.tab_exam_subject_list
where dt = '{{ execution_date | cst_ds }}'
distribute by 1;

